﻿<%@ Page Language="C#" MasterPageFile="~/keshi.master" AutoEventWireup="true" CodeFile="xinxichaxun.aspx.cs" Inherits="_Default" Title="信息查询" %>
<%-- 在此处添加内容控件 --%>
<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="ContentPlaceHolder1">
<script language="javascript" type="text/javascript">
// <!CDATA[



// ]]>
</script>

    <br />
    &nbsp;
    <div style="z-index: 101; left: 4px; width: 238px; position: absolute; top: 9px;
        height: 358px; border-left-color: #22a1ff; border-bottom-color: #6699ff; border-top-color: #6699ff; border-right-style: dotted; border-right-color: #6666ff; border-bottom-style: double; background-color: transparent; background-image: url(photo/框框0.jpg); background-repeat: no-repeat;">
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
        &nbsp; &nbsp; &nbsp;<br />
        <br />
        <br />
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</div>
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <div style="z-index: 102; left: 423px; width: 79px; position: absolute; top: 197px;
        height: 148px; border-left-color: #0099ff; border-bottom-color: #6666ff; border-top-color: #4c76ff; border-right-color: #3366ff; background-repeat: no-repeat; background-image: url(photo/修饰1.jpg);" id="DIV1" onclick="return DIV1_onclick()">
        <div style="z-index: 101; left: -168px; border-bottom-color: #627bff;
            width: 779px; border-top-style: dotted; border-top-color: #627bff; position: absolute; top: -196px; height: 356px;
            border-bottom-style: none; background-position: left bottom; background-repeat: no-repeat; border-right: #627bff thin solid; border-left: #627bff thin solid;">
            <div style="z-index: 101; border-left-color: #00afcf; left: 787px; border-bottom-color: #00afcf;
                width: 161px; border-top-style: double; border-top-color: #00afcf; border-right-style: double;
                border-left-style: double; position: absolute; top: -3px; height: 1px; border-right-color: #00afcf;
                border-bottom-style: double">
                <asp:TreeView ID="TreeView1" runat="server" Font-Size="14pt" ForeColor="Black" ImageSet="BulletedList4"
                    ShowExpandCollapse="False" ShowLines="True" Width="117px">
                    <ParentNodeStyle Font-Bold="False" />
                    <HoverNodeStyle Font-Size="11pt" Font-Underline="True" ForeColor="#5555DD" />
                    <SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px"
                        VerticalPadding="0px" />
                    <Nodes>
                        <asp:TreeNode ShowCheckBox="False" Text="列表查询" Value="列表查询">
                            <asp:TreeNode ShowCheckBox="False" Text="问 题" Value="问 题"></asp:TreeNode>
                            <asp:TreeNode ShowCheckBox="False" Text="需 求" Value="需 求"></asp:TreeNode>
                        </asp:TreeNode>
                        <asp:TreeNode ShowCheckBox="False" Text="回复查询" Value="回复查询">
                            <asp:TreeNode ShowCheckBox="False" Text="信息科" Value="信息科"></asp:TreeNode>
                            <asp:TreeNode ShowCheckBox="False" Text="其他科" Value="其他科"></asp:TreeNode>
                        </asp:TreeNode>
                        <asp:TreeNode ShowCheckBox="False" Text="历史查询" Value="历史查询">
                            <asp:TreeNode ShowCheckBox="False" Text="问 题" Value="问 题"></asp:TreeNode>
                            <asp:TreeNode ShowCheckBox="False" Text="需 求" Value="需 求"></asp:TreeNode>
                        </asp:TreeNode>
                    </Nodes>
                    <NodeStyle Font-Names="Tahoma" Font-Size="10pt" ForeColor="Black" HorizontalPadding="5px"
                        NodeSpacing="0px" VerticalPadding="0px" />
                </asp:TreeView>
                &nbsp;
                &nbsp; &nbsp; &nbsp; &nbsp;
            </div>
            <div style="z-index: 102; border-left-color: #7ba9ff; left: 797px; border-bottom-color: #7ba9ff;
                width: 149px; border-top-color: #7ba9ff; position: absolute; top: 225px; height: 141px; border-right-color: #7ba9ff; background-image: url(photo/边框2.jpg); font-size: 11pt;">
            </div>
            <span style="font-size: 11pt"></span>
            <div style="font-size: 11pt; z-index: 103; left: 240px; width: 533px; position: absolute;
                top: 1px; height: 370px; overflow: auto; border-right: blue thin double; border-top: blue thin double; border-left: blue thin double; border-bottom: blue thin double; visibility: visible;">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
                    AutoGenerateColumns="False" DataSourceID="SqlDataSource6"
                    Height="19px" Width="519px" AllowSorting="True" CellPadding="4" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" SelectedIndex="0" TabIndex="-1" GridLines="Vertical" PageSize="7" CellSpacing="1" Font-Size="XX-Small" ForeColor="#333333">
                    <Columns>
                        <asp:CommandField ShowSelectButton="True" />
                        <asp:BoundField DataField="message_id" HeaderText="信息id" SortExpression="message_id" />
                        <asp:BoundField DataField="title" HeaderText="标题" SortExpression="title" />
                        <asp:BoundField DataField="detail" HeaderText="内容" SortExpression="detail" />
                        <asp:BoundField DataField="dept_name" HeaderText="科室" SortExpression="dept_name" />
                        <asp:BoundField DataField="flag_name" HeaderText="紧急性" SortExpression="flag_name" />
                        <asp:BoundField DataField="submit_user" HeaderText="提交人" SortExpression="submit_user" />
                        <asp:BoundField DataField="submit_time" HeaderText="提交时间" SortExpression="submit_time" />
                        <asp:BoundField DataField="state_name" HeaderText="状态" SortExpression="state_name" />
                        <asp:BoundField DataField="type_name" HeaderText="类型" SortExpression="type_name" />
                    </Columns>
                    <RowStyle Wrap="True" BackColor="#EFF3FB" />
                    <SelectedRowStyle HorizontalAlign="Left" BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <FooterStyle BackColor="#507CD1" ForeColor="White" BorderColor="Black" Font-Bold="True" Font-Size="Smaller" />
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" />
                    <EditRowStyle BackColor="#2461BF" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="Data Source=GDEMO\SQLEXPRESS;Initial Catalog=feedback;User ID=sa;Password=123"
                   ProviderName="System.Data.SqlClient" 
                   SelectCommand="
                   SELECT message_list.message_id, message_list.title, message_list.submit_time, zd_ry.Name AS submit_user, message_list.detail, zd_state.state_name, zd_type.type_name, zd_department.dept_name, zd_flag.flag_name FROM message_list INNER JOIN zd_type ON message_list.type_no = zd_type.type INNER JOIN zd_flag ON message_list.serious_no = zd_flag.flag INNER JOIN zd_state ON message_list.status_no = zd_state.state INNER JOIN zd_department ON message_list.Department = zd_department.dept_no INNER JOIN zd_ry ON message_list.submit_user = zd_ry.user_id order by message_list.message_id ">
                  
                </asp:SqlDataSource>
                &nbsp;
            </div>
            <span style="font-size: 11pt">&nbsp;信息id： &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                <asp:DropDownList
                    ID="DropDownList6" runat="server" Width="52px" OnSelectedIndexChanged="DropDownList6_SelectedIndexChanged" >
                    <asp:ListItem Value="1">查询</asp:ListItem>
                    <asp:ListItem Value="0">显示</asp:ListItem>
                </asp:DropDownList><br />
            </span><asp:DropDownList ID="DropDownList1" runat="server" Width="128px" DataSourceID="SqlDataSource1" DataTextField="message_id" DataValueField="message_id" AutoPostBack="True" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=GDEMO\SQLEXPRESS;Initial Catalog=feedback;User ID=sa;Password=123"
                    ProviderName="System.Data.SqlClient" SelectCommand=" SELECT [message_id] FROM [message_list]" >
                </asp:SqlDataSource>
            <br />
            <span style="font-size: 11pt">&nbsp;标 题：<br />
                <asp:DropDownList ID="DropDownList2" runat="server" Width="128px" DataSourceID="SqlDataSource2" DataTextField="title" DataValueField="title" EnableTheming="True">
                </asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=GDEMO\SQLEXPRESS;Initial Catalog=feedback;User ID=sa;Password=123"
                    ProviderName="System.Data.SqlClient" SelectCommand="SELECT [title] FROM [message_list]">
                </asp:SqlDataSource>
            </span><br />
            <span style="font-size: 11pt">&nbsp;提交人：<br />
                <asp:DropDownList ID="DropDownList3" runat="server" Width="128px" DataSourceID="SqlDataSource3" DataTextField="Name" DataValueField="Name">
                </asp:DropDownList><asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="Data Source=GDEMO\SQLEXPRESS;Initial Catalog=feedback;User ID=sa;Password=123"
                     SelectCommand="SELECT [Name] FROM [zd_ry]" ProviderName="System.Data.SqlClient">
                </asp:SqlDataSource>
                &nbsp;</span><br />
            <span style="font-size: 11pt">&nbsp;提交时间：<br />
            </span>
            <asp:TextBox ID="TextBox1" runat="server" Width="160px"></asp:TextBox><br />
            <span style="font-size: 11pt">&nbsp;至<br />
            </span>
            <asp:TextBox ID="TextBox2" runat="server" Width="159px"></asp:TextBox><br />
            <span style="font-size: 11pt">&nbsp;处理人：<br />
                <asp:DropDownList ID="DropDownList4" runat="server" Width="128px" >
                 
                </asp:DropDownList>&nbsp;</span><br />
            <span style="font-size: 11pt">&nbsp;提交时间：<br />
            </span>
            <asp:TextBox ID="TextBox3" runat="server" Width="157px"></asp:TextBox><br />
            <span style="font-size: 11pt">&nbsp;至<br />
            </span>
            <asp:TextBox ID="TextBox4" runat="server" Width="159px"></asp:TextBox><br />
            <span style="font-size: 11pt">&nbsp;科 室：<br />
                <asp:DropDownList
                    ID="DropDownList5" runat="server" Width="128px" DataSourceID="SqlDataSource4" DataTextField="dept_name" DataValueField="dept_name" >
                </asp:DropDownList><asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:Ling %>"
                    SelectCommand="SELECT [dept_name] FROM [zd_department]"></asp:SqlDataSource>
            </span>&nbsp;&nbsp; &nbsp;<asp:Button ID="Button1" runat="server" Text="查 询" /></div>
    </div>
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
    <br />
</asp:Content>
